package cn.net.csit.platform_cloud.basicmodel.service;

import cn.net.csit.platform_cloud.base.PtColumnModel;

import java.util.List;
import java.util.Map;

public interface IBackupDataService {
    //创建表及字段
    void createTable(java.lang.String NewTableName,List<Map<String,String>> columnNameList);
    //创建空表
    void createNullTable(java.lang.String NewTableName);
    //删除表
    void deleteTable(java.lang.String NewTableName);
    //清空表
    void truncateTable(java.lang.String NewTableName);
    //增加表字段
    void addColumnList(String tableName, List<String> columnNameList);

    void addColumns(String tableName, List<PtColumnModel> columnNameList);

    //删除表字段
    void delColumns(String tableName, List<String> columnNameList);
    //查询表是否已经存在
    String isTargetTableExistInDB(String dataBaseName,String NewTableName);
    //自定义sql,查询任意数据返回多个字段
    List<Map<String,String>> customQueryItem(StringBuilder sqlContent);
}
